-- ****** Object: Table ASM_GEP.GEP_DATI_NOSTD Script Date: 17/12/2012 23:23:35 ******
CREATE TABLE "GEP_DATI_NOSTD" (
  "NST_COD_PRATICA" NUMBER NOT NULL,
  "NST_POT_RICH_CONTR" NUMBER(22,0) NULL,
  "NST_POT_RICH_TOLL" NUMBER(22,0) NULL,
  "NST_FASI_RICH" NUMBER(22,0) NULL,
  "NST_TENS_RICH" NUMBER(22,0) NULL,
  "NST_USO_RICH" VARCHAR2(30 BYTE) NULL,
  "NST_RAGSOC_NEW" VARCHAR2(100 BYTE) NULL,
  "NST_PIVA_NEW" VARCHAR2(11 BYTE) NULL,
  "NST_CODFIS_NEW" VARCHAR2(16 BYTE) NULL,
  "NST_IND_FORNIT_NEW" VARCHAR2(100 BYTE) NULL,
  "NST_DATA_FINE_FORN" date NULL,
  "NST_NON_ESEGUIRE_PRIMA" date NULL,
  "NST_PRESENZA_CLIENTE_FINALE" varchar2(2 BYTE) NULL,
  "NST_TIPO_CONN"VARCHAR2(100 BYTE) NULL,
  "NST_PREVENTIVO"VARCHAR2(2 BYTE) NULL,
  "NST_NRO_PRA_RIF" VARCHAR2(10 BYTE) NULL)
/
CREATE UNIQUE INDEX "PK_GEP_DATI_NOSTD"
  ON "GEP_DATI_NOSTD" ( 
    "NST_COD_PRATICA")
/
ALTER TABLE "GEP_DATI_NOSTD" ADD ( 
  CONSTRAINT "PK_GEP_DATI_NOSTD" 
    PRIMARY KEY ( "NST_COD_PRATICA") 
    USING INDEX "PK_GEP_DATI_NOSTD" 
    ENABLE 
    VALIDATE )
/
